import java.sql.*;

//TIP To <b>Run</b> code, press <shortcut actionId="Run"/> or
// click the <icon src="AllIcons.Actions.Execute"/> icon in the gutter.
public class Main {
    public static void main(String[] args) {
        //1.加载驱动
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");

        //2.获取连接

            Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/jdbc?characterEncoding=utf-8",
                    "root","2333");
            if (conn!=null){
                System.out.println("连接成功");
            }

        }catch (ClassNotFoundException e){
            throw new RuntimeException(e);
        }catch (SQLException e){
            throw new RuntimeException(e);
        }

        //3.编写sql语句
        String sql = "select * from sys_user ";

        //4.预处理sql  .var
        /*PreparedStatement preparedStatement=
                conn.prepareStatement(sql);

        //5如果有参数，设置参数

        //6.执行sal语句
        ResultSet resultSet = preparedStatement.executeQuery();

        //7。如果是查询就遍历结果，如果是增删改，判断是否成功
        while (resultSet.next()){
            int id = resultSet.getInt(1);
            String name = resultSet.getString(2);
            String pass = resultSet.getString(3);
            System.out.println(id+"-----"+name+"------");
        }

        resultSet.close();
        preparedStatement.close();
        conn.close();
*/

    }
}